SELECT CONCAT(FirstName, ' ', MiddleName, ' ', LastName) AS [Employee name],
	YEAR(e.HireDate) AS [Hire date],
	d.Name AS [Department name]
	FROM Employees e
		JOIN Departments d
			ON e.DepartmentID = d.DepartmentID
				WHERE YEAR(e.HireDate) BETWEEN YEAR('1995/01/01') AND YEAR('2005/12/31') AND d.Name IN('Sales', 'Finance')